IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SrvrInstncAlias]') AND type in (N'U'))
BEGIN
     DROP TABLE [dbo].[SrvrInstncAlias]
END
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[SrvrInstncAlias](
     [SrvrInstncId]       [int]          NOT NULL,
     [SrvrInstncFullName] [varchar](255) NOT NULL,
     [DoNotUseFlag]       [tinyint]      NOT NULL CONSTRAINT [DF_SrvrInstncAlias_DoNotUseFlag] DEFAULT ((0)),
     [LastModDt]          [datetime]     NOT NULL CONSTRAINT [DF_SrvrInstncAlias_LastModDt] DEFAULT (getdate()),
     CONSTRAINT [PK_SrvrInstncAlias] PRIMARY KEY CLUSTERED ( [SrvrInstncId] ASC, [SrvrInstncFullName] ASC )
) ON [PRIMARY]
GO

SET ANSI_PADDING OFF
GO
